<!--
TODO: regions/cities needs to change with on click event on previous combo box

Examples of how to do ( php dynamic select boxes ):
http://www.9lessons.info/2010/08/dynamic-dependent-select-box-using.html
http://www.plus2net.com/php_tutorial/php_drop_down_list.php
-->
<form name="search" method="post" action="./hairstylists.php">
	<fieldset> 
		<legend>Search hairstylists</legend>
Hairstylist Name: <input type="text" name="find_hairstylist" /><br/>
Salon Name: <input type="text" name="find_salon" /><br/>

Country: <Select NAME="find_country">
<?php
$sql = "SELECT CountryId, Country FROM Countries"
	." ORDER BY Country ASC";
$rs = mysql_query($sql);
echo "<option value=\"-1\"> </option>\n  ";
while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"".$row['CountryId']."\">".$row['Country']."</option>\n  ";
}
?>
</Select><br/>

Province/State: <Select NAME="find_region">
<?php
$sql = "SELECT RegionId, Region FROM Regions"
	//." WHERE CountryId = ".$find_country
	." ORDER BY Region ASC";
$rs = mysql_query($sql);
echo "<option value=\"-1\"> </option>\n  ";
while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"".$row['RegionId']."\">".$row['Region']."</option>\n  ";
}
?>
</Select><br/>

City <Select NAME="find_city">
<?php
$sql = "SELECT CityId, City FROM Cities"
	//." WHERE CountryId = ".$find_country
	//." WHERE RegionId = ".$find_region
	." ORDER BY City ASC";
$rs = mysql_query($sql);
echo "<option value=\"-1\"> </option>\n  ";
while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"".$row['CityId']."\">".$row['City']."</option>\n  ";
}
?>
</Select><br/>

<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
    </fieldset> 
</form>